Import Excel file (.xls)

TRACKS >> IMPORT TRACKS > FROM EXCEL SPREADSHEET (*.xls)

Composer Catalog allows you to import tracks with three different techniques. The first technique is importing from a Microsoft Excel spreadsheet. It is very important to note that the spreadsheet must conform to certain formatting.

To import a Microsoft Excel spreadsheet, go to TRACKS >> IMPORT TRACKS >> FROM EXCEL SPREADSHEET (*.xls)

Then you will see a screen that asks you for the directory that contains the spreadsheet. Click on the button and navigate to that folder directory. Once you select the folder, you will then see a list of any .xls spreadsheets that are in that directory. Find the one you want to import and click on it.

IMPORTANT:
In order for the spreadsheet to import, it must be in a certain format. Take a moment and look at the template .xls file provided. To find where the template is located, look at the text on the bottom of this screen (see image below).

After you select your spreadsheet and the format is good, the next screen will display the data. (see image below). If you need to make any changes, you can do it directly in this gridview.

Three fields are mandatory: track title, track type, and genre.

There are a couple fields that need to contain certain values:

Track Type - must be either an "i" or "s" (instrumental/song)
Genre - any genre listed needs to already be in the system. If any genre is not found in the system, it was ask if you want to create them automatically, before importing the spreadsheet.
Registered - must be either a "y" or "n" (yes/no)
Is Signed - must be either a "y" or "n" (yes/no)

There are some buttons on the top right of the form:

Toggle Import Track
This button will toggle the Import Track checkbox on all the tracks in the spreadsheet. If an Import Track checkbox is toggled on, it will chosen to import into the Composer Catalog library. If it is not checked, it will be disregarded.

Toggle Track Completed
This button will toggle the Track Completed checkbox on all the tracks in the spreadsheet. If a Track Completed checkbox is toggled on, it will set the status of the track as "complete". If it is not checked, it will be flagged as incomplete. If any tracks are flagged as incomplete, you can later go to TRACKS >> TAG INCOMPLETE TRACKS and perform some global changes.

Evaluate Import
Once you have successfully loaded up the spreadsheet and made any necessary edits, you can now click on the Evaluate Import button and it will make sure that the spreadsheet conforms to the proper format. If it does, it will ask youto import the files into Composer Catalog. If it does not conform, Composer Catalog will let you know what fields (and row of the field), needs editing.